malloy logoMalloy Documentation
Getting Started
document The Tao of Malloy
document Key Features
Language Reference
document Introduction
document Malloy Quickstart
document Models
document Explores
document Queries
document Fields
document Types
document Expressions
document Ordering and Limiting
document Joins
document Filters
document Nested Queries
document Aggregates
document Imports and Exports
Common Patterns
document Year Over Year Analysis
document Foreign Sums and Averages
document Percent of Total
document Cohort Analysis
document Pivot Limits
document Sessionized Data
Rendering Results
document Tables and Dashboards
document Bar Charts
document Line Charts
document Shape Maps
document Segment Maps
document Scatter Charts
Examples
document eCommerce Analysis
document NTSB Flight Database
document The Name Game
document Google Analytics GA360
Iowa Liquor - An Analysis
document About the Data Set
document The Malloy Data Model
document Basic Calculations
document Analysis: Products and Brands
document Bucketing and Mapping
document Dashboards
previousSegment Maps
eCommerce Analysisnext

Scatter Charts

Scatter charts compare two numeric values. The data styles for the subsequent examples is:

{
  "seats_by_distance": {
    "renderer": "scatter_chart"
  }
}

Run as a nested subtable 

query: flights->{
  nest: seats_by_distance_scatter_chart is {
    group_by: seats is aircraft.aircraft_models.seats
    group_by: distance is distance
    aggregate: route_count is count(distinct concat(origin_code, destination_code))
  }
}
seats_​by_​distance_​scatter_​chart
0100200300400500seats02,0004,000distance129route_count

Run as a trellis 

query: flights->{
  group_by: origin_code
  nest: seats_by_distance_scatter_chart is {
    group_by: seats is aircraft.aircraft_models.seats
    group_by: distance is distance
    aggregate: route_count is count(distinct concat(origin_code, destination_code))
  }
}
origin_​code seats_​by_​distance_​scatter_​chart
ABE 050100150200seats05001,000distance1route_count
ABI 01020304050seats0100200300distance1route_count
ABQ 0100200300seats05001,0001,5002,000distance1route_count
ABY 020406080seats050100150distance1route_count
ACK 01020304050seats0100200distance1route_count